package com.osce.score.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.csce.domain.entity.score.ScoreExExamMark;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
 * 考试打分表Mapper接口
 *
 * @author zzx
 * @since 2024-04-11
 */
@Repository
public interface ScoreExExamMarkMapper extends BaseMapper<ScoreExExamMark> {

    /**
     * 查询考试打分表
     *
     * @param id 考试打分表主键
     * @return 考试打分表
     */
    ScoreExExamMark selectScoreExExamMarkById(Long id);

    /**
     * 查询考试打分表列表
     *
     * @param scoreExExamMark 考试打分表
     * @return 考试打分表集合
     */
    List<ScoreExExamMark> selectScoreExExamMarkList(ScoreExExamMark scoreExExamMark);

    /**
     * 新增考试打分表
     *
     * @param scoreExExamMark 考试打分表
     * @return 结果
     */
    int insertScoreExExamMark(ScoreExExamMark scoreExExamMark);

    /**
     * 修改考试打分表
     *
     * @param scoreExExamMark 考试打分表
     * @return 结果
     */
    int updateScoreExExamMark(ScoreExExamMark scoreExExamMark);

    /**
     * 删除考试打分表
     *
     * @param id 考试打分表主键
     * @return 结果
     */
    int deleteScoreExExamMarkById(Long id);

    /**
     * 批量删除考试打分表
     *
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    int deleteScoreExExamMarkByIds(Long[] ids);

    ScoreExExamMark selectScoreExExamMark(ScoreExExamMark scoreExExamMark);

    ScoreExExamMark selectScoreExExamMarkByAllotAndUser(@Param("allotId") Long allotId,@Param("sheetId")Long sheetId,@Param("userId") Long userId,@Param("examinerId") Long examinerId);

    List<ScoreExExamMark> selectScoreExExamMarkByAllot(@Param("allotId") Long allotId);
}
